Heavy rain has seen many parts of the northern beaches flooded, and emergency services called out to help.